<?php

class IntropageController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column2';

	/**
	 * @var CActiveRecord the currently loaded data model instance.
	 */
	private $_model;

	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
				'actions'=>array('index','view'),
				'users'=>array('@'),
			),
			array('allow', // allow authenticated user to perform 'create' and 'update' actions
				'actions'=>array('create','update', 'noticeFail'),
				'users'=>array('@'),
			),
			array('allow', // allow admin user to perform 'admin' and 'delete' actions
				'actions'=>array('admin','delete', 'noticeFail', 'accounting', 'statistic'),
				'users'=>array('admin'),
			),
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	/**
	 * Displays a particular model.
	 */
	public function actionView()
	{
		$this->render('view',array(
			'model'=>$this->loadModel(),
		));
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate()
	{
		$model=new Intropage;
                $course = Course::model()->findbyPk($_GET['id_course']);
		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Intropage']))
		{
			$model->attributes=$_POST['Intropage'];
                        $model->id_course = $course->id;
                        $model->createDate = date("Y-m-d");
                        $course->status = 1;
                        $course->is_getted = 1;
                        
			if($model->save()&& $course->save())
				$this->redirect(array('view','id'=>$model->id));
		}
                
		$this->render('create',array(
			'model'=>$model,
                        'course'=>$course
		));
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionUpdate()
	{
		$model=$this->loadModel();
                $course = Course::model()->findbyPk($model->id_course);
		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Intropage']))
		{
			$model->attributes=$_POST['Intropage'];
			if($model->save())
				$this->redirect(array('view','id'=>$model->id));
		}
             
		$this->render('update',array(
			'model'=>$model,
                        'course'=>$course
		));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'index' page.
	 */
	public function actionDelete()
	{
		if(Yii::app()->request->isPostRequest)
		{
			// we only allow deletion via POST request
			$this->loadModel()->delete();

			// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
			if(!isset($_GET['ajax']))
				$this->redirect(array('index'));
		}
		else
			throw new CHttpException(400,'Invalid request. Please do not repeat this request again.');
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex()
	{
		$dataProvider=new CActiveDataProvider('Intropage');
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
		));
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin()
	{
		$model=new Intropage('search');
		$model->unsetAttributes();  // clear any default values
		if(isset($_GET['Intropage']))
			$model->attributes=$_GET['Intropage'];

		$this->render('admin',array(
			'model'=>$model,
		));
	}

	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 */
	public function loadModel()
	{
		if($this->_model===null)
		{
			if(isset($_GET['id']))
				$this->_model=Intropage::model()->findbyPk($_GET['id']);
			if($this->_model===null)
				throw new CHttpException(404,'The requested page does not exist.');
		}
		return $this->_model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param CModel the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='intropage-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}

        public function actionNoticeFail() {
//            $criteria=new CDbCriteria;
//            $criteria->select='*';  // only select the 'title' column
//            $criteria->condition='(id_course = :id_course) and (failDate is null)';
//            $criteria->params=array(':id_course'=>$_GET['id_course']);
            $model=Intropage::model()->findByPK($_GET['id']);
            if($model===null) {
				throw new CHttpException(404,'The requested page does not exist.');
            }
		if(isset($_POST['Intropage']))
		{
                    //set attribute for intropage
			$model->attributes=$_POST['Intropage'];
                        $model->failDate = date("Y-m-d");

                        $course=Course::model()->findbyPk($model->id_course);
                        $course->status = 0;
			if($model->save() && $course->save()) {
				$this->redirect(array('index'));
                        }
		}
               
		$this->render('notice',array(
			'model'=>$model,
		));
        }
        public function actionAccounting() {
            $this->render('accounting',array());
        }
        public function actionStatistic() {
            $criteria1=new CDbCriteria;
            $criteria1->select='*';  // only select the 'title' column
            $criteria1->condition='(createDate between :start_date and :end_date) and (failDate is null)';
            $criteria1->params=array(':start_date'=>$_POST['start_date'], ':end_date'=>$_POST['end_date']);
            $success_intropages=Intropage::model()->findAll($criteria1);

            $criteria2=new CDbCriteria;
            $criteria2->select='*';  // only select the 'title' column
            $criteria2->condition='(failDate is not null) and (failDate between :start_date and :end_date)';
            $criteria2->params=array(':start_date'=>$_POST['start_date'], ':end_date'=>$_POST['end_date']);
            $fail_intropages=Intropage::model()->findAll($criteria2);

            //sum salary
            $success_num = count($success_intropages);
            $success_income = 0;
            foreach ($success_intropages as $intropage) {
                $success_income += $intropage->salary;
            }

            $fail_num = count($fail_intropages);
            $fail_income = 0;
            foreach ($fail_intropages as $intropage) {
                $fail_income += $intropage->salary;
            }
             $provider1 = new CActiveDataProvider('Intropage', array(
                    'pagination'=>array(
                        'pageSize'=>10,
                    ),
                    'sort'=>array(
                    'attributes'=>array(
                         'id'
                    )),

			'criteria'=>$criteria1,
		));
             $provider2 = new CActiveDataProvider('Intropage', array(
                     'pagination'=>array(
                            'pageSize'=>10,
                        ),
                     'sort'=>array(
                        'attributes'=>array(
                             'id'
                        )),
			'criteria'=>$criteria2,
		));
            $this->renderPartial('_statistic',array(
                'provider1'=>$provider1,
                'provider2'=>$provider2,
                'success_num'=>$success_num,
                'success_income'=>$success_income,
                'fail_num'=>$fail_num,
                'fail_income'=>$fail_income
            ));
        }
}
